How can I optimize a slow MySQL query involving multiple large tables

visit shbcf.ru